---
title: DB-CLL-058 — Look up a case number for a printed letter
summary: Look up a case number for a printed letter
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-058 — Look up a case number for a printed letter

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-058 |
| Operation type | Misc |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsLetterRequest |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to look up the case number |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL.vw_cases](../database-tables.md#legal.vw_cases) | SELECT | case number lookup |

## Sample SQL

```sql
Select
  vw_cases.case_number
From
  LEGAL.vw_cases
Where
  vw_cases.legal_case_seq_num = :LegalCaseID
```

## Operations and processes

- [Print a legal letter](../operations/print-legal-letter.md)

## Business rules

- [BR-CLM-LGL-020](../business-rules.md#br-clm-lgl-020-letter-hearing-date-renders-empty-rather-than-a-default-value)
- [BR-CLM-LGL-021](../business-rules.md#br-clm-lgl-021-policy-short-name-truncation-and-special-case-substitution)
- [BR-CLM-LGL-022](../business-rules.md#br-clm-lgl-022-state-entity-attorney-title-override)
- [BR-CLM-LGL-023](../business-rules.md#br-clm-lgl-023-worker-attorney-display-fallback-chain)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsLetterRequest.vb`